Go to AgTreks Home




Note: Going home clears all of these panels.

Synchronize panels by clicking the panel directional buttons found at the top of the panel.

Synchronize panels by clicking the panel directional buttons found at the top of the panel.

Synchronize panels by clicking the panel directional buttons found at the top of the panel.

Synchronize panels by clicking the panel directional buttons found at the top of the panel.


Get
7- Corn and Soybean Same Year Machinery Stock Analysis

Resource Stock Analyzer Views

Corn Machinery Least Cost Timeliness Penalties Costs

Introduction
This tool generates a variety of basic resource stock statistics for DevTreks operating budgets and capital budgets.

Analysis View Description
Sample data sets are used in DevTreks tutorials (V214a).

Version: 1.7.0

Feedback About crops/budget/7- Corn and Soybean Same Year Machinery Stock Analysis/273071763/budgetresources02a

Step 1 of 3. Make Selections


Date: 05/14/2014

Step 2 of 3. Analyze

Relations

Use In Childs?
Overwrite Childs?

Step 3 of 3. Save

Method 1. Do you wish to save step 2's calculations? These calculations are viewed by opening this particular calculator addin.



Instructions (beta)

Step 1

  • Step 1. Base Calculations To Analyze: Make sure the data being analyzed corresponds to either operating budgets or capital budgets.
  • Step 1. Analysis Type: Totals add together the resource stocks being analyzed. Mean and Standard deviationis not available yet.

Step 2

  • Step 2. Use Same Calculator Pack In Descendants?: True to insert or update this same calculator in children.
  • Step 2. What If Tag Name: Instructional videos explaining the use of what-if scenario calculations should be viewed before changing or using this parameter.
  • Step 2. Base Resource Calculations To Analyze Type: The calculator chosen should actually be used, and used fairly frequently, in the underlying data being analyzed.
  • Step 2. Related Calculators Type: Name of the "Related Calculator Type" found in descendants. Runs calculations using the data found in those descendant linked views. This property takes precedence over the "Base Resoure Calculations to Analyze Type" property.

Step 3

  • Step 3. Save Using: The Save command saves xml data the Save Text command saves csv data.


Reminder: The 'Resource Stock Totals' analyzer requires running the underlying NPV calculator after inserting, deleting, or updating, this linked view (that keeps the NPV calculator's linked views synchronized with these linkedviews).


Current view of document
7- Corn and Soybean Same Year Machinery Stock Analysis
Budget Group
Operating Budgets, Common Agricultural Examples
Budget
7- Corn and Soybean Same Year Machinery Stock Analysis
Costs
1252050.000 126206.000 66361.156 3380.915 71500.000 7700.000 149000.000 3300.000 268.000 238.000
12136.382 26.000 24547.380 2457.600 160.000 18935.970 48.505 113.000 245.649 35426.795
2340.000 1851.990 n.a. 79155.79 69742.07
Time Period
Corn for Grain
Costs
Market Value Salvage Value Cap Recov Cost THI Cost Starting Hrs Planned Use Hrs Useful Life Hrs Horsepower Speed Width
Fuel Amount Fuel Price Fuel Cost Labor Amount Labor Price Labor Cost Lube Oil Amounts Lube Oil Price Lube Oil Cost Repair Cost
Equiv PTO HP Field Efficiency Amount Operating Cost Alloc OH Cost
Labor Available (hours per day) Area Covered (ac/ha per day) Planned vs Actual Start Date Probable Field Days Needed Probable Finish Date Timeliness Penalty Days From Start Timeliness Penalty (percent) Additional Penalty (percent) Timeliness Penalty Cost (currency) Timeliness Penalty Cost Per Hour
Operation
Chisel Plow
Costs
129100.000 12300.000 3396.494 295.608 7000.000 600.000 14000.000 330.000 25.000 20.000
930.337 2.000 1860.673 203.700 12.000 1330.607 4.423 10.000 22.999 2724.672
200.000 184.000 n.a. 5938.95 3692.10
---
Input : Chisel Plow, Maximum 1 foot depth, Chisel or Sweep Type, Drawn or Mounted,
Costs
13100.00 1300.00 1350.4243 107.0977 1000 100 2000 140 5.0000 10.0000
0.0000 0.0000 0.0000 97.0000 0.00 0.0000 0.0000 5.0000 0.0000 944.5084
100 85.0000 0.1941 944.51 1457.52
Input : Tractor, 2-Wheel Drive, 190-220 PTO HP
Costs
116000.00 11000.00 2046.0695 188.5098 6000 500 12000 190 20.0000 10.0000
930.3367 2.0000 1860.6734 106.7000 12.00 1330.6072 4.4232 5.0000 22.9987 1780.1634
100 99.0000 0.1941 4994.44 2234.58
Operation
Plant, Corn Grain, medium tractor, Example 1
Input : Grain Drill, Most Common Spacing, Plain, 15-17 Openers
Costs
14000.00 1400.00 1919.2068 50.1480 750 200 1500 140 5.0000 14.0000
0.0000 0.0000 0.0000 92.4000 0.00 0.0000 0.0000 5.0000 0.0000 1033.2000
100 70.0000 0.1684 1033.20 1969.35
Input : Seed, grain
Input : Example 1- Tractor, New Calculators
Costs
53610.00 7566.00 1140.4344 51.3828 0 300 6000 140 5.0000 10.0000
697.3680 2.0000 1394.7360 92.4000 12.00 1108.8000 2.9484 3.0000 8.8536 208.0512
100 80.0000 0.1684 2720.44 1191.82
Operation
Apply Anyhdrous
Costs
84100.000 8400.000 319.765 29.698 6000.000 500.000 12000.000 150.000 20.000 10.000
238.365 2.000 495.424 23.100 12.000 288.070 0.781 5.000 4.064 279.411
140.000 99.000 n.a. 1066.97 349.46
---
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
Costs
84100.00 8400.00 319.7649 29.6982 6000 500 12000 150 20.0000 10.0000
238.3647 2.0000 495.4236 23.1000 12.00 288.0696 0.7812 5.0000 4.0635 279.4113
140 99.0000 0.0417 1066.97 349.46
Input : Anhydrous Applicator Rental
Input : Fertilizer, Anhydrous Ammonia
Operation
Field Cultivate
Costs
90430.000 9000.000 1501.617 116.906 7000.000 700.000 14000.000 290.000 27.000 20.000
591.883 2.000 1183.766 145.950 12.000 953.373 2.585 10.000 13.448 1260.577
200.000 184.000 n.a. 3411.16 1618.52
---
Input : Cultivator, Row Crop, 6 Row
Costs
6330.00 600.00 443.3475 18.6191 1000 200 2000 140 7.0000 10.0000
0.0000 0.0000 0.0000 69.5000 0.00 0.0000 0.0000 5.0000 0.0000 335.8588
100 85.0000 0.1387 335.86 461.97
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
Costs
84100.00 8400.00 1058.2696 98.2869 6000 500 12000 150 20.0000 10.0000
591.8829 2.0000 1183.7657 76.4500 12.00 953.3732 2.5854 5.0000 13.4483 924.7184
100 99.0000 0.1387 3075.31 1156.56
Operation
Weed Control, corn grain
Costs
39490.000 3900.000 1503.021 37.304 6750.000 700.000 13500.000 220.000 26.500 20.000
1260.002 2.000 2520.005 195.000 16.000 1606.108 1.502 10.000 7.712 991.507
200.000 65.990 n.a. 5125.33 1540.32
---
Input : Sprayer, Field Crop, Power, Boom-Type, Tractor Mounted, w- 300 gallon Spray
Costs
5890.00 600.00 935.3858 24.5310 750 200 1500 140 6.5000 10.0000
0.0000 0.0000 0.0000 97.5000 0.00 0.0000 0.0000 5.0000 0.0000 501.5985
100 65.0000 0.1953 501.60 959.92
Input : Tractor, 2-Wheel Drive, 70-89 PTO HP
Costs
33600.00 3300.00 567.6353 12.7725 6000 500 12000 80 20.0000 10.0000
1260.0023 2.0000 2520.0045 97.5000 16.00 1606.1078 1.5015 5.0000 7.7123 489.9083
100 0.9900 0.1953 4623.73 580.41
Input : EPTC (Eptan), 7E-(Eradicane), 6-7#-GAL EC
Operation
Combine, corn grain
Input : Combine, Self Propelled with Grain Head, Large capacity
Costs
159000.00 16000.00 20868.9288 885.7041 1500 300 3000 140 3.0000 10.0000
1631.3430 2.0000 3390.6468 216.1500 12.00 2695.5084 6.8972 5.0000 35.8613 8799.5058
100 70.0000 0.3929 14921.52 21754.63
Operation
Haul, corn grain
Input : Tractor, 2-Wheel Drive, 110-129 PTO HP
Costs
63800.00 6380.00 1466.8881 136.2583 6000 500 12000 140 20.0000 10.0000
1054.3540 2.0000 2108.7080 139.7000 12.00 1742.1352 4.4577 5.0000 23.1775 1281.8999
100 99.0000 0.2538 5155.92 1603.15
Input : Wagon, Gravity Unload, w- Box and Running, Gear, and Tires, 200-400 bu, w-0
Costs
4200.00 400.00 874.8141 22.6568 750 200 1500 140 5.0000 10.0000
0.0000 0.0000 0.0000 127.0000 0.00 0.0000 0.0000 5.0000 0.0000 571.9826
100 65.0000 0.2538 571.98 897.47
Time Period Totals
Time Period
Soybeans for Grain
Costs
Market Value Salvage Value Cap Recov Cost THI Cost Starting Hrs Planned Use Hrs Useful Life Hrs Horsepower Speed Width
Fuel Amount Fuel Price Fuel Cost Labor Amount Labor Price Labor Cost Lube Oil Amounts Lube Oil Price Lube Oil Cost Repair Cost
Equiv PTO HP Field Efficiency Amount Operating Cost Alloc OH Cost
Labor Available (hours per day) Area Covered (ac/ha per day) Planned vs Actual Start Date Probable Field Days Needed Probable Finish Date Timeliness Penalty Days From Start Timeliness Penalty (percent) Additional Penalty (percent) Timeliness Penalty Cost (currency) Timeliness Penalty Cost Per Hour
Operation
Chisel Plow
Costs
129100.000 12300.000 3396.494 295.608 7000.000 600.000 14000.000 330.000 25.000 20.000
930.337 2.000 1860.673 203.700 12.000 1330.607 4.423 10.000 22.999 2724.672
200.000 184.000 n.a. 5938.95 3692.10
---
Input : Chisel Plow, Maximum 1 foot depth, Chisel or Sweep Type, Drawn or Mounted,
Costs
13100.00 1300.00 1350.4243 107.0977 1000 100 2000 140 5.0000 10.0000
0.0000 0.0000 0.0000 97.0000 0.00 0.0000 0.0000 5.0000 0.0000 944.5084
100 85.0000 0.1941 944.51 1457.52
Input : Tractor, 2-Wheel Drive, 190-220 PTO HP
Costs
116000.00 11000.00 2046.0695 188.5098 6000 500 12000 190 20.0000 10.0000
930.3367 2.0000 1860.6734 106.7000 12.00 1330.6072 4.4232 5.0000 22.9987 1780.1634
100 99.0000 0.1941 4994.44 2234.58
Operation
Seeding and Planting, soybeans
Input : Seed, soybeans
Input : Grain Drill, Most Common Spacing, Plain, 15-17 Openers
Costs
14000.00 1400.00 1919.2068 50.1480 750 200 1500 140 5.0000 14.0000
0.0000 0.0000 0.0000 92.4000 0.00 0.0000 0.0000 5.0000 0.0000 1033.2000
100 70.0000 0.1684 1033.20 1969.35
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
Costs
84100.00 8400.00 1279.0596 118.7928 6000 500 12000 150 20.0000 10.0000
715.3692 2.0000 1430.7384 92.4000 12.00 1152.2784 3.1248 5.0000 16.2540 1117.6452
100 99.0000 0.1684 3716.92 1397.85
Operation
Field Cultivate
Costs
90430.000 9000.000 1501.617 116.906 7000.000 700.000 14000.000 290.000 27.000 20.000
591.883 2.000 1183.766 145.950 12.000 953.373 2.585 10.000 13.448 1260.577
200.000 184.000 n.a. 3411.16 1618.52
---
Input : Cultivator, Row Crop, 6 Row
Costs
6330.00 600.00 443.3475 18.6191 1000 200 2000 140 7.0000 10.0000
0.0000 0.0000 0.0000 69.5000 0.00 0.0000 0.0000 5.0000 0.0000 335.8588
100 85.0000 0.1387 335.86 461.97
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
Costs
84100.00 8400.00 1058.2696 98.2869 6000 500 12000 150 20.0000 10.0000
591.8829 2.0000 1183.7657 76.4500 12.00 953.3732 2.5854 5.0000 13.4483 924.7184
100 99.0000 0.1387 3075.31 1156.56
Operation
Weed Control, soybeans
Costs
69690.000 6980.000 2062.979 129.176 6750.000 700.000 13500.000 280.000 26.500 20.000
809.445 2.000 1618.890 204.900 12.000 1337.466 3.422 10.000 17.794 1486.506
200.000 164.000 n.a. 4460.66 2192.16
---
Input : Glyphosate (Roundup), 4#-GAL EC, 2003
Input : Sprayer, Field Crop, Power, Boom-Type, Tractor Mounted, w- 300 gallon Spray
Costs
5890.00 600.00 936.8248 24.5687 750 200 1500 140 6.5000 10.0000
0.0000 0.0000 0.0000 97.6500 0.00 0.0000 0.0000 5.0000 0.0000 502.3702
100 65.0000 0.1953 502.37 961.39
Input : Tractor, 2-Wheel Drive, 110-129 PTO HP
Costs
63800.00 6380.00 1126.1543 104.6078 6000 500 12000 140 20.0000 10.0000
809.4450 2.0000 1618.8900 107.2500 12.00 1337.4660 3.4223 5.0000 17.7938 984.1358
100 99.0000 0.1953 3958.29 1230.76
Operation
Combine, soybeans
Input : Combine, Self Propelled with Grain Head, Large capacity
Costs
159000.00 16000.00 20868.9288 885.7041 1500 300 3000 140 3.0000 10.0000
1631.3430 2.0000 3390.6468 216.1500 12.00 2695.5084 6.8972 5.0000 35.8613 8799.5058
100 70.0000 0.3929 14921.52 21754.63
Operation
Haul beans, soybean
Input : Tractor, 2-Wheel Drive, 110-129 PTO HP
Costs
63800.00 6380.00 1466.8881 136.2583 6000 500 12000 140 20.0000 10.0000
1054.3540 2.0000 2108.7080 139.7000 12.00 1742.1352 4.4577 5.0000 23.1775 1281.8999
100 99.0000 0.2538 5155.92 1603.15
Input : Wagon, Gravity Unload, w- Box and Running, Gear, and Tires, 200-400 bu, w-0
Costs
4200.00 400.00 874.8141 22.6568 750 200 1500 140 5.0000 10.0000
0.0000 0.0000 0.0000 127.0000 0.00 0.0000 0.0000 5.0000 0.0000 571.9826
100 65.0000 0.2538 571.98 897.47
Time Period Totals
Dataset: 7- Corn and Soybean Same Year Machinery Stock Analysis IRI This operating budget demonstrates best practices for conducting machinery cost estimates for crop enterprises.









Uploading a new file will replace any existing file. If necessary, please package and download the existing file prior to this action. If the file has been uploaded successfully, this page will refresh and show the new file information. If the file can't be uploaded (i.e. exceeds 60MB, unsupported mimetype, bad xml, bad html) this page will refresh and show the existing file information.

The file has been uploaded.